IF EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND name = 'sp_RolePermission_Delete')
	DROP PROCEDURE dbo.sp_RolePermission_Delete
GO
CREATE PROCEDURE dbo.sp_RolePermission_Delete
	@RoleID INT
AS
BEGIN
	SET NOCOUNT OFF

	DECLARE @_RoleID INT
	SET @_RoleID = @RoleID

	DELETE FROM dbo.RolePermissions WHERE RoleID = @_RoleID

	SELECT TOP 1 * FROM dbo.RolePermissions WHERE 1 = 2
END
GO